<!DOCTYPE html><html lang="zh-CN" data-theme="light"><head><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width,initial-scale=1"><title>MySQL表查询实训 | YoiaL</title><meta name="keywords" content="学习笔记,菜鸟入门,MySQL"><meta name="author" content="John Doe"><meta name="copyright" content="John Doe"><meta name="format-detection" content="telephone=no"><meta name="theme-color" content="#ffffff"><meta name="description" content="MySQL表查询实训笔记 设bookstores数据库有三张表如下： book表：    b_id b_type b_name b_author b_publish b_time b_price b_number b_dis     B116628 计算机 计算机基础 张小华 清华大学出版社 2017&#x2F;9&#x2F;8 40 10 0.8   B116629 计算机 数据库概论 李雪 人民邮电出版社 201">
<meta property="og:type" content="article">
<meta property="og:title" content="MySQL表查询实训">
<meta property="og:url" content="https://liaoyia.gitee.io/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/index.html">
<meta property="og:site_name" content="YoiaL">
<meta property="og:description" content="MySQL表查询实训笔记 设bookstores数据库有三张表如下： book表：    b_id b_type b_name b_author b_publish b_time b_price b_number b_dis     B116628 计算机 计算机基础 张小华 清华大学出版社 2017&#x2F;9&#x2F;8 40 10 0.8   B116629 计算机 数据库概论 李雪 人民邮电出版社 201">
<meta property="og:locale" content="zh_CN">
<meta property="og:image" content="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png">
<meta property="article:published_time" content="2020-04-29T08:21:56.000Z">
<meta property="article:modified_time" content="2021-03-01T09:03:48.822Z">
<meta property="article:author" content="John Doe">
<meta property="article:tag" content="学习笔记">
<meta property="article:tag" content="菜鸟入门">
<meta property="article:tag" content="MySQL">
<meta name="twitter:card" content="summary">
<meta name="twitter:image" content="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png"><link rel="shortcut icon" href="/liaoyia/img/favicon.png"><link rel="canonical" href="https://liaoyia.gitee.io/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/"><link rel="preconnect" href="//cdn.jsdelivr.net"/><link rel="preconnect" href="//busuanzi.ibruce.info"/><link rel="stylesheet" href="/liaoyia/css/index.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free/css/all.min.css" media="print" onload="this.media='all'"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/node-snackbar/dist/snackbar.min.css" media="print" onload="this.media='all'"><script>const GLOBAL_CONFIG = { 
  root: '/liaoyia/',
  algolia: undefined,
  localSearch: {"path":"search.xml","languages":{"hits_empty":"找不到您查询的内容：${query}"}},
  translate: {"defaultEncoding":1,"translateDelay":0,"msgToTraditionalChinese":"繁","msgToSimplifiedChinese":"簡"},
  noticeOutdate: undefined,
  highlight: {"plugin":"highlighjs","highlightCopy":true,"highlightLang":true},
  copy: {
    success: '复制成功',
    error: '复制错误',
    noSupport: '浏览器不支持'
  },
  relativeDate: {
    homepage: true,
    post: true
  },
  runtime: '',
  date_suffix: {
    just: '刚刚',
    min: '分钟前',
    hour: '小时前',
    day: '天前',
    month: '个月前'
  },
  copyright: undefined,
  lightbox: 'fancybox',
  Snackbar: {"chs_to_cht":"你已切换为繁体","cht_to_chs":"你已切换为简体","day_to_night":"你已切换为深色模式","night_to_day":"你已切换为浅色模式","bgLight":"#49b1f5","bgDark":"#121212","position":"bottom-center"},
  source: {
    jQuery: 'https://cdn.jsdelivr.net/npm/jquery@latest/dist/jquery.min.js',
    justifiedGallery: {
      js: 'https://cdn.jsdelivr.net/npm/justifiedGallery/dist/js/jquery.justifiedGallery.min.js',
      css: 'https://cdn.jsdelivr.net/npm/justifiedGallery/dist/css/justifiedGallery.min.css'
    },
    fancybox: {
      js: 'https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.js',
      css: 'https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.css'
    }
  },
  isPhotoFigcaption: true,
  islazyload: false,
  isanchor: false
}</script><script id="config-diff">var GLOBAL_CONFIG_SITE = { 
  isPost: true,
  isHome: false,
  isHighlightShrink: false,
  isToc: true,
  postUpdate: '2021-03-01 17:03:48'
}</script><noscript><style type="text/css">
  #nav {
    opacity: 1
  }
  .justified-gallery img {
    opacity: 1
  }

  #recent-posts time,
  #post-meta time {
    display: inline !important
  }
</style></noscript><script>(win=>{
    win.saveToLocal = {
      set: function setWithExpiry(key, value, ttl) {
        if (ttl === 0) return
        const now = new Date()
        const expiryDay = ttl * 86400000
        const item = {
          value: value,
          expiry: now.getTime() + expiryDay,
        }
        localStorage.setItem(key, JSON.stringify(item))
      },

      get: function getWithExpiry(key) {
        const itemStr = localStorage.getItem(key)

        if (!itemStr) {
          return undefined
        }
        const item = JSON.parse(itemStr)
        const now = new Date()

        if (now.getTime() > item.expiry) {
          localStorage.removeItem(key)
          return undefined
        }
        return item.value
      }
    }
  
    win.getScript = url => new Promise((resolve, reject) => {
      const script = document.createElement('script')
      script.src = url
      script.async = true
      script.onerror = reject
      script.onload = script.onreadystatechange = function() {
        const loadState = this.readyState
        if (loadState && loadState !== 'loaded' && loadState !== 'complete') return
        script.onload = script.onreadystatechange = null
        resolve()
      }
      document.head.appendChild(script)
    })
  
      win.activateDarkMode = function () {
        document.documentElement.setAttribute('data-theme', 'dark')
        if (document.querySelector('meta[name="theme-color"]') !== null) {
          document.querySelector('meta[name="theme-color"]').setAttribute('content', '#0d0d0d')
        }
      }
      win.activateLightMode = function () {
        document.documentElement.setAttribute('data-theme', 'light')
        if (document.querySelector('meta[name="theme-color"]') !== null) {
          document.querySelector('meta[name="theme-color"]').setAttribute('content', '#ffffff')
        }
      }
      const t = saveToLocal.get('theme')
    
          if (t === 'dark') activateDarkMode()
          else if (t === 'light') activateLightMode()
        
      const asideStatus = saveToLocal.get('aside-status')
      if (asideStatus !== undefined) {
        if (asideStatus === 'hide') {
          document.documentElement.classList.add('hide-aside')
        } else {
          document.documentElement.classList.remove('hide-aside')
        }
      }
    })(window)</script><link rel="stylesheet" href="/css/fishes.css"><style type="text/css">#toggle-sidebar { left : 100px }</style><meta name="generator" content="Hexo 5.4.0"></head><body><div id="web_bg"></div><div id="sidebar"><div id="menu-mask"></div><div id="sidebar-menus"><div class="author-avatar"><img class="avatar-img" src="/liaoyia/null" onerror="onerror=null;src='/img/friend_404.gif'" alt="avatar"/></div><div class="site-data"><div class="data-item is-center"><div class="data-item-link"><a href="/liaoyia/archives/"><div class="headline">文章</div><div class="length-num">16</div></a></div></div><div class="data-item is-center"><div class="data-item-link"><a href="/liaoyia/tags/"><div class="headline">标签</div><div class="length-num">9</div></a></div></div><div class="data-item is-center"><div class="data-item-link"><a href="/liaoyia/categories/"><div class="headline">分类</div><div class="length-num">6</div></a></div></div></div><hr/><div class="menus_items"><div class="menus_item"><a class="site-page" href="/liaoyia/"><i class="fa-fw fas fa-home"></i><span> 首页</span></a></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fa-fw fas fa-compass"></i><span> 目录</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/archives/"><i class="fa-fw fas fa-archive"></i><span> 归档</span></a></li><li><a class="site-page" href="/liaoyia/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></li><li><a class="site-page" href="/liaoyia/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fa-fw fa fa-heartbeat"></i><span> 娱乐</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/music/"><i class="fa-fw fas fa-music"></i><span> 音乐</span></a></li><li><a class="site-page" href="/liaoyia/movies/"><i class="fa-fw fas fa-video"></i><span> 电影</span></a></li><li><a class="site-page" href="/liaoyia/books/"><i class="fa-fw fa fa-book"></i><span> 书籍</span></a></li><li><a class="site-page" href="/liaoyia/games/"><i class="fa-fw fa fa-gamepad"></i><span> 游戏</span></a></li><li><a class="site-page" href="/liaoyia/ziyu/"><i class="fa-fw fa-fw fas fa-cubes"></i><span> 自言自语</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw laptop-code"></i><span> 🎯</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/messages/"><i class="fa-fw fa-fw fas fa-comment-dots"></i><span> 留言板</span></a></li><li><a class="site-page" href="/liaoyia/link/"><i class="fa-fw fas fa-link"></i><span> Link</span></a></li><li><a class="site-page" href="/liaoyia/about/"><i class="fa-fw fa-fw fas fa-heart"></i><span> 关于我</span></a></li></ul></div></div></div></div><div class="post" id="body-wrap"><header class="post-bg" id="page-header" style="background-image: url('https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png')"><nav id="nav"><span id="blog_name"><a id="site-name" href="/liaoyia/">YoiaL</a></span><div id="menus"><div id="search-button"><a class="site-page social-icon search"><i class="fas fa-search fa-fw"></i><span> 搜索</span></a></div><div class="menus_items"><div class="menus_item"><a class="site-page" href="/liaoyia/"><i class="fa-fw fas fa-home"></i><span> 首页</span></a></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fa-fw fas fa-compass"></i><span> 目录</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/archives/"><i class="fa-fw fas fa-archive"></i><span> 归档</span></a></li><li><a class="site-page" href="/liaoyia/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></li><li><a class="site-page" href="/liaoyia/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fa-fw fa fa-heartbeat"></i><span> 娱乐</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/music/"><i class="fa-fw fas fa-music"></i><span> 音乐</span></a></li><li><a class="site-page" href="/liaoyia/movies/"><i class="fa-fw fas fa-video"></i><span> 电影</span></a></li><li><a class="site-page" href="/liaoyia/books/"><i class="fa-fw fa fa-book"></i><span> 书籍</span></a></li><li><a class="site-page" href="/liaoyia/games/"><i class="fa-fw fa fa-gamepad"></i><span> 游戏</span></a></li><li><a class="site-page" href="/liaoyia/ziyu/"><i class="fa-fw fa-fw fas fa-cubes"></i><span> 自言自语</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw laptop-code"></i><span> 🎯</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/liaoyia/messages/"><i class="fa-fw fa-fw fas fa-comment-dots"></i><span> 留言板</span></a></li><li><a class="site-page" href="/liaoyia/link/"><i class="fa-fw fas fa-link"></i><span> Link</span></a></li><li><a class="site-page" href="/liaoyia/about/"><i class="fa-fw fa-fw fas fa-heart"></i><span> 关于我</span></a></li></ul></div></div><div id="toggle-menu"><a class="site-page"><i class="fas fa-bars fa-fw"></i></a></div></div></nav><div id="post-info"><h1 class="post-title">MySQL表查询实训</h1><div id="post-meta"><div class="meta-firstline"><span class="post-meta-date"><i class="far fa-calendar-alt fa-fw post-meta-icon"></i><span class="post-meta-label">发表于</span><time class="post-meta-date-created" datetime="2020-04-29T08:21:56.000Z" title="发表于 2020-04-29 16:21:56">2020-04-29</time><span class="post-meta-separator">|</span><i class="fas fa-history fa-fw post-meta-icon"></i><span class="post-meta-label">更新于</span><time class="post-meta-date-updated" datetime="2021-03-01T09:03:48.822Z" title="更新于 2021-03-01 17:03:48">2021-03-01</time></span></div><div class="meta-secondline"><span class="post-meta-separator">|</span><span class="post-meta-wordcount"><i class="far fa-file-word fa-fw post-meta-icon"></i><span class="post-meta-label">字数总计:</span><span class="word-count">1.7k</span><span class="post-meta-separator">|</span><i class="far fa-clock fa-fw post-meta-icon"></i><span class="post-meta-label">阅读时长:</span><span>7分钟</span></span><span class="post-meta-separator">|</span><span class="post-meta-pv-cv"><i class="far fa-eye fa-fw post-meta-icon"></i><span class="post-meta-label">阅读量:</span><span id="busuanzi_value_page_pv"></span></span></div></div></div></header><main class="layout" id="content-inner"><div id="post"><article class="post-content" id="article-container"><link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/hint.css/2.4.1/hint.min.css"><h1>MySQL表查询实训笔记</h1>
<h2 id="设bookstores数据库有三张表如下：">设bookstores数据库有三张表如下：</h2>
<h4 id="book表：">book表：</h4>
<table>
<thead>
<tr>
<th>b_id</th>
<th>b_type</th>
<th>b_name</th>
<th>b_author</th>
<th>b_publish</th>
<th>b_time</th>
<th>b_price</th>
<th>b_number</th>
<th>b_dis</th>
</tr>
</thead>
<tbody>
<tr>
<td>B116628</td>
<td>计算机</td>
<td>计算机基础</td>
<td>张小华</td>
<td>清华大学出版社</td>
<td>2017/9/8</td>
<td>40</td>
<td>10</td>
<td>0.8</td>
</tr>
<tr>
<td>B116629</td>
<td>计算机</td>
<td>数据库概论</td>
<td>李雪</td>
<td>人民邮电出版社</td>
<td>2018/5/6</td>
<td>24.5</td>
<td>20</td>
<td>0.9</td>
</tr>
<tr>
<td>B116630</td>
<td>计算机</td>
<td>C语言程序设计</td>
<td>王天明</td>
<td>高等教育出版社</td>
<td>2015/4/9</td>
<td>33.5</td>
<td>32</td>
<td>0.8</td>
</tr>
<tr>
<td>B116631</td>
<td>数学</td>
<td>高等数学</td>
<td>赵夏天</td>
<td>清华大学出版社</td>
<td>2017/10/12</td>
<td>37</td>
<td>45</td>
<td>0.7</td>
</tr>
<tr>
<td>B116632</td>
<td>数学</td>
<td>线性代数</td>
<td>李晓婷</td>
<td>高等教育出版社</td>
<td>2018/12/4</td>
<td>45</td>
<td>33</td>
<td>0.9</td>
</tr>
<tr>
<td>B116633</td>
<td>数学</td>
<td>离散数学</td>
<td>张天天</td>
<td>清华大学出版社</td>
<td>2018/1/3</td>
<td>55</td>
<td>56</td>
<td>0.8</td>
</tr>
<tr>
<td>B116634</td>
<td>数学</td>
<td>数学分析</td>
<td>王敏</td>
<td>人民邮电出版社</td>
<td>2015/11/22</td>
<td>49</td>
<td>71</td>
<td>0.9</td>
</tr>
<tr>
<td>B116635</td>
<td>英语</td>
<td>新概念英语1</td>
<td>赵虎</td>
<td>人民教育出版社</td>
<td>2016/6/8</td>
<td>43</td>
<td>25</td>
<td>0.7</td>
</tr>
<tr>
<td>B116636</td>
<td>英语</td>
<td>新概念英语2</td>
<td>李欣甜</td>
<td>高等教育出版社</td>
<td>2017/9/7</td>
<td>34.5</td>
<td>43</td>
<td>0.8</td>
</tr>
<tr>
<td>B116637</td>
<td>英语</td>
<td>新概念英语3</td>
<td>唐晓米</td>
<td>人民教育出版社</td>
<td>2016/9/5</td>
<td>28</td>
<td>44</td>
<td>0.9</td>
</tr>
</tbody>
</table>
<h4 id="member表：">member表：</h4>
<table>
<thead>
<tr>
<th>m_id</th>
<th>m_name</th>
<th>m_gender</th>
<th>m_pw</th>
<th>m_tel</th>
<th>m_time</th>
</tr>
</thead>
<tbody>
<tr>
<td>V00001</td>
<td>张星星</td>
<td>男</td>
<td>123456</td>
<td>13428743747</td>
<td></td>
</tr>
<tr>
<td>V00002</td>
<td>李阳阳</td>
<td>男</td>
<td>666666</td>
<td>13437528739</td>
<td></td>
</tr>
<tr>
<td>V00003</td>
<td>王泰</td>
<td>男</td>
<td>888888</td>
<td>13765784980</td>
<td></td>
</tr>
<tr>
<td>V00004</td>
<td>赵诗</td>
<td>女</td>
<td>234567</td>
<td>13876453728</td>
<td>2018/1/4</td>
</tr>
<tr>
<td>V00005</td>
<td>李莎</td>
<td>女</td>
<td>123456</td>
<td>18848739012</td>
<td>2018/1/5</td>
</tr>
<tr>
<td>V00006</td>
<td>张群</td>
<td>女</td>
<td>123456</td>
<td></td>
<td>2017/3/9</td>
</tr>
<tr>
<td>V00007</td>
<td>陈小军</td>
<td>男</td>
<td>123456</td>
<td></td>
<td>2017/3/10</td>
</tr>
<tr>
<td>V00008</td>
<td>张金龙</td>
<td>男</td>
<td>123456</td>
<td></td>
<td>2017/3/11</td>
</tr>
<tr>
<td>V00009</td>
<td>王雪</td>
<td>女</td>
<td>123456</td>
<td></td>
<td>2017/3/12</td>
</tr>
<tr>
<td>V00010</td>
<td>赵兰芬</td>
<td>女</td>
<td>123456</td>
<td></td>
<td>2017/3/13</td>
</tr>
</tbody>
</table>
<h4 id="bookorser表">bookorser表</h4>
<table>
<thead>
<tr>
<th>m_id</th>
<th>b_id</th>
<th>o_id</th>
<th>o_number</th>
<th>o_time</th>
<th>o_fh</th>
<th>o_sh</th>
<th>o_jq</th>
</tr>
</thead>
<tbody>
<tr>
<td>V00001</td>
<td>B116628</td>
<td>1000000001</td>
<td>5</td>
<td>2019/12/10</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00001</td>
<td>B116629</td>
<td>1000000001</td>
<td>2</td>
<td>2019/12/10</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00001</td>
<td>B116633</td>
<td>1000000001</td>
<td>3</td>
<td>2019/12/10</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00002</td>
<td>B116629</td>
<td>1000000002</td>
<td>2</td>
<td>2020/1/10</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00002</td>
<td>B116634</td>
<td>1000000002</td>
<td>3</td>
<td>2020/1/10</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00003</td>
<td>B116637</td>
<td>1000000003</td>
<td>2</td>
<td>2020/2/27</td>
<td>是</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>V00004</td>
<td>B116630</td>
<td>1000000004</td>
<td>1</td>
<td>2020/3/20</td>
<td>是</td>
<td>否</td>
<td>否</td>
</tr>
<tr>
<td>V00001</td>
<td>B116630</td>
<td>1000000004</td>
<td>1</td>
<td>2020/3/20</td>
<td>是</td>
<td>否</td>
<td>否</td>
</tr>
<tr>
<td>V00002</td>
<td>B116631</td>
<td>1000000005</td>
<td>3</td>
<td>2020/3/26</td>
<td>否</td>
<td>否</td>
<td>否</td>
</tr>
<tr>
<td>V00002</td>
<td>B116628</td>
<td>1000000005</td>
<td>2</td>
<td>2020/3/26</td>
<td>否</td>
<td>否</td>
<td>否</td>
</tr>
</tbody>
</table>
<h3 id="已吸收的知识点回顾：">已吸收的知识点回顾：</h3>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">父查询</span><br><span class="line"></span><br><span class="line">where (子查询)</span><br><span class="line"></span><br><span class="line">in、any[some]、all、exists 、比较运算符   --&gt; 作为父查询和子查询的链接条件</span><br></pre></td></tr></table></figure>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">&#x3D;   	&#x2F;&#x2F; 值1 &#x3D; 值2</span><br><span class="line"></span><br><span class="line">&#x3D; all   &#x2F;&#x2F; 值集合(所有值都相等)	</span><br><span class="line"></span><br><span class="line">x &#x3D; all(1,2,3)  [需要满足x&#x3D;1 and x&#x3D;2 and x&#x3D;3时才成立]</span><br><span class="line"></span><br><span class="line">&#x3D; any	&#x2F;&#x2F; 值集合(任一值相等则满足条件)</span><br><span class="line"></span><br><span class="line">x &#x3D; any(1,2,3)  [只要满足x&#x3D;1 or x&#x3D;2 or x&#x3D;3任一一个条件即成立]</span><br><span class="line"></span><br><span class="line">--&gt; in 和 &#x3D;any 效果一样</span><br><span class="line">--&gt; 在实际运用中看子查询条件返回几个值，如果是一个则用 &#x3D;</span><br><span class="line">--&gt; 当你不能确定子查询返回值是一个或是多个时，则用 &#x3D;any 和 &#x3D;all </span><br></pre></td></tr></table></figure>
<h4 id="子查询习题">子查询习题</h4>
<ul>
<li>1、查找比《高等数学》库存量还要高的图书编号和书名。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select b_id as 图书编号,b_name as 会员姓名 from book </span><br><span class="line">where b_number &gt;</span><br><span class="line">(select b_number from book where b_name&#x3D;&#39;高等数学&#39;);</span><br><span class="line"></span><br><span class="line">也可以使用链接查询：</span><br><span class="line">select s2.b_id,s2.b_name</span><br><span class="line">from book as s1 join book as s2 </span><br><span class="line">on s2.b_number&gt;s1.b_number</span><br><span class="line">where s1.b_name&#x3D;&#39;高等数学&#39;;</span><br></pre></td></tr></table></figure>
<ul>
<li>2、查询member表中是否存在编号V00011的会员，如果存在，则查询book表中所有记录。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select * from  book</span><br><span class="line">where exists </span><br><span class="line">(select * from member where m_id&#x3D;&#39;v00011&#39;);  &#x2F;&#x2F;无v00011会员，返回数据为空。</span><br><span class="line"></span><br><span class="line">&#x2F;&#x2F;拓展：查询member表中是否存在编号V00001的会员，如果存在，则查询bookorder表中该会员记录。</span><br><span class="line"></span><br><span class="line">select * from  bookorder</span><br><span class="line">where exists </span><br><span class="line">(select * from member where m_id&#x3D;&#39;v00001&#39;);</span><br><span class="line"></span><br><span class="line">运行后查询的是所有会员记录....</span><br><span class="line"></span><br><span class="line">在子查询中添加bookorder.m_id&#x3D;m_id试试 ：</span><br><span class="line"></span><br><span class="line">select * from  bookorder</span><br><span class="line">where exists </span><br><span class="line">(select * from member where bookorder.m_id&#x3D;m_id and  m_id&#x3D;&#39;v00001&#39;);</span><br><span class="line"></span><br><span class="line">这里得出一个结论，只能在子查询引用父查询的表，父查询无法引用子查询的表。</span><br></pre></td></tr></table></figure>
<ul>
<li>3、查询会员编号为“V00001”的会员购买的所有图书的编号、书名、价格。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select b_id as 图书编号,b_name as 会员姓名,b_price as 图书价格 from book </span><br><span class="line">where b_id in [这里也可以使用&#x2F;&#x3D;any]</span><br><span class="line">(select b_id from bookorder  where m_id &#x3D;&#39;v00001&#39;);</span><br><span class="line"></span><br></pre></td></tr></table></figure>
<ul>
<li>4、查询book表中比所有“高等教育出版社”出版的图书库存量都低的图书详细信息。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select * from  book</span><br><span class="line">where b_number &lt;all</span><br><span class="line">(select b_number from book </span><br><span class="line">where b_publish &#x3D;&#39;高等教育出版社&#39;);</span><br></pre></td></tr></table></figure>
<ul>
<li>5、在bookstore数据库中查找购买了《计算机基础》这本图书的会员信息。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select * from member &#x2F;&#x2F;查找会员信息</span><br><span class="line">where m_id &#x3D; any</span><br><span class="line">(select m_id as 会员编号 from bookorder &#x2F;&#x2F;查询购买了计算机基础这本书的会员编号</span><br><span class="line">where b_id &#x3D;</span><br><span class="line">(select b_id from book where b_name &#x3D; &#39;计算机基础&#39;)); &#x2F;&#x2F;查找计算机基础这本书</span><br><span class="line"></span><br><span class="line">三重查询</span><br></pre></td></tr></table></figure>
<h3 id="在bookstore数据库中完成以下题目：">在bookstore数据库中完成以下题目：</h3>
<ul>
<li>1、统计没有收货的订单一共有多少个，输出数量及其单号。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select count(distinct o_id) as 数量,group_concat( distinct o_id) as 订单号</span><br><span class="line">from bookorder where o_sh&#x3D;&#39;否&#39;;</span><br><span class="line"></span><br><span class="line">&#x2F;&#x2F; count 统计行数 </span><br><span class="line">&#x2F;&#x2F; group_concat 汇总函数</span><br></pre></td></tr></table></figure>
<ul>
<li>2、查找价格最高的图书编号、书名和价格。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select b_id as 图书编号,b_name as 书名 ,b_price as 价格 from book </span><br><span class="line">where b_price&#x3D;(select max(b_price) from book) ;</span><br><span class="line"></span><br><span class="line">&#x2F;&#x2F;或者用按价格降序（从高到低）排序完成</span><br><span class="line">&#x2F;&#x2F;limit 1  取第一行</span><br><span class="line">&#x2F;&#x2F;order by  字段 desc  降序排序</span><br><span class="line"></span><br><span class="line">select b_id as 图书编号,b_name as 书名 ,b_price as 价格</span><br><span class="line">from book order by b_price desc limit 0,1;</span><br></pre></td></tr></table></figure>
<ul>
<li>3、按出版年份统计价格30元以上的图书有多少本，输出其中大于两本的。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select year(b_time) as 年份,count(*) as 数量</span><br><span class="line">from book </span><br><span class="line">where b_price&gt;30</span><br><span class="line">group by year(b_time)    </span><br><span class="line">having count(*)&gt;2;	</span><br><span class="line"></span><br><span class="line">&#x2F;&#x2F; group by 分组后取字段中年份</span><br><span class="line">&#x2F;&#x2F; having 分组后条件筛选</span><br><span class="line"></span><br><span class="line">这里需要记住一个知识点，group by year(b_time) 分组后，前面的select查询条件也可以跟上year(b_time)查询条件。</span><br></pre></td></tr></table></figure>
<ul>
<li>4、使用子查询查找没有订购清华大学出版社出版的图书的会员编号和会员名。</li>
</ul>
<figure class="highlight plain"><table><tr><td class="code"><pre><span class="line">select m_id as 会员编号,m_name as 会员姓名 from member</span><br><span class="line">where not m_id &#x3D; any</span><br><span class="line">(select distinct m_id  from bookorder</span><br><span class="line">where b_id in</span><br><span class="line">(select b_id from book where b_publish &#x3D; &#39;清华大学出版社&#39;));</span><br><span class="line"></span><br><span class="line">注意： 表中可以看出有会员多次都买清华大学出版社出版的图书，distinct 是去除重复</span><br><span class="line">	  筛选条件还可以用 not in &#x2F; !&#x3D;all</span><br></pre></td></tr></table></figure>
<ul>
<li>5、查找所有张姓会员的姓名、性别，以及订购图书的编号、订购数量与订购时间。</li>
</ul>
<figure class="highlight sql"><table><tr><td class="code"><pre><span class="line"><span class="keyword">select</span> m_name,m_gender,b_id,o_number,o_time</span><br><span class="line"><span class="keyword">from</span>  <span class="keyword">member</span> <span class="keyword">left</span> <span class="keyword">join</span>  bookorder </span><br><span class="line"><span class="keyword">on</span> member.m_id<span class="operator">=</span>bookorder.m_id</span><br><span class="line"><span class="keyword">where</span> m_name <span class="keyword">like</span> <span class="string">&#x27;张%&#x27;</span>;</span><br></pre></td></tr></table></figure>
<ul>
<li>6、使用连接查询查找销售量最高的三本图书的书名、作者和价格。</li>
</ul>
<figure class="highlight sql"><table><tr><td class="code"><pre><span class="line"><span class="keyword">select</span> b_name <span class="keyword">as</span> 书名,b_author <span class="keyword">as</span> 作者,b_price <span class="keyword">as</span> 价格</span><br><span class="line"><span class="keyword">from</span> book <span class="keyword">join</span> bookorder</span><br><span class="line"><span class="keyword">on</span> book.b_id<span class="operator">=</span>bookorder.b_id</span><br><span class="line"><span class="keyword">group</span> <span class="keyword">by</span>  bookorder.b_id</span><br><span class="line"><span class="keyword">order</span> <span class="keyword">by</span>  <span class="built_in">sum</span>(o_number) <span class="keyword">desc</span> </span><br><span class="line">limit <span class="number">0</span>,<span class="number">3</span>;</span><br><span class="line"></span><br><span class="line"><span class="keyword">group</span> <span class="keyword">by</span> 分组</span><br><span class="line"><span class="keyword">order</span> <span class="keyword">by</span> 排序</span><br><span class="line">sum 求和</span><br><span class="line">limit 输出</span><br></pre></td></tr></table></figure>
</article><div class="post-copyright"><div class="post-copyright__author"><span class="post-copyright-meta">文章作者: </span><span class="post-copyright-info"><a href="mailto:null">John Doe</a></span></div><div class="post-copyright__type"><span class="post-copyright-meta">文章链接: </span><span class="post-copyright-info"><a href="https://liaoyia.gitee.io/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/">https://liaoyia.gitee.io/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/</a></span></div><div class="post-copyright__notice"><span class="post-copyright-meta">版权声明: </span><span class="post-copyright-info">本博客所有文章除特别声明外，均采用 <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/" target="_blank">CC BY-NC-SA 4.0</a> 许可协议。转载请注明来自 <a href="https://liaoyia.gitee.io" target="_blank">YoiaL</a>！</span></div></div><div class="tag_share"><div class="post-meta__tag-list"><a class="post-meta__tags" href="/liaoyia/tags/%E5%AD%A6%E4%B9%A0%E7%AC%94%E8%AE%B0/">学习笔记</a><a class="post-meta__tags" href="/liaoyia/tags/%E8%8F%9C%E9%B8%9F%E5%85%A5%E9%97%A8/">菜鸟入门</a><a class="post-meta__tags" href="/liaoyia/tags/MySQL/">MySQL</a></div><div class="post_share"><div class="social-share" data-image="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png" data-sites="facebook,twitter,wechat,weibo,qq"></div><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/social-share.js/dist/css/share.min.css" media="print" onload="this.media='all'"><script src="https://cdn.jsdelivr.net/npm/social-share.js/dist/js/social-share.min.js" defer></script></div></div><nav class="pagination-post" id="pagination"><div class="prev-post pull-left"><a href="/liaoyia/2020/06/22/css%E5%B1%82%E5%8F%A0%E6%A0%B7%E5%BC%8F%E8%A1%A8/"><img class="prev-cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lyHTML.png" onerror="onerror=null;src='/liaoyia/img/404.jpg'" alt="cover of previous post"><div class="pagination-info"><div class="label">上一篇</div><div class="prev_info">Css层叠样式表期末复习</div></div></a></div><div class="next-post pull-right"><a href="/liaoyia/2020/04/09/MySQL%E6%95%B0%E6%8D%AE%E6%9B%B4%E6%96%B0/"><img class="next-cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lysee.png" onerror="onerror=null;src='/liaoyia/img/404.jpg'" alt="cover of next post"><div class="pagination-info"><div class="label">下一篇</div><div class="next_info">MySQL数据更新和单表查询</div></div></a></div></nav><div class="relatedPosts"><div class="headline"><i class="fas fa-thumbs-up fa-fw"></i><span> 相关推荐</span></div><div class="relatedPosts-list"><div><a href="/liaoyia/2020/04/09/MySQL数据更新/" title="MySQL数据更新和单表查询"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lysee.png" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-04-09</div><div class="title">MySQL数据更新和单表查询</div></div></a></div><div><a href="/liaoyia/2020/04/06/MySQL数据完整性约束/" title="MySQL数据完整性约束"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lysel.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-04-06</div><div class="title">MySQL数据完整性约束</div></div></a></div><div><a href="/liaoyia/2020/03/22/MySQL创建和管理数据库/" title="初探 MySQL"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-03-22</div><div class="title">初探 MySQL</div></div></a></div><div><a href="/liaoyia/2020/06/26/MySQL基础/" title="Mysql回顾"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymysql.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-06-26</div><div class="title">Mysql回顾</div></div></a></div><div><a href="/liaoyia/2020/06/22/css层叠样式表/" title="Css层叠样式表期末复习"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lyHTML.png" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-06-22</div><div class="title">Css层叠样式表期末复习</div></div></a></div><div><a href="/liaoyia/2020/04/08/Markdown/" title="Markdown基本语法总结"><img class="cover" src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymd.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2020-04-08</div><div class="title">Markdown基本语法总结</div></div></a></div></div></div></div><div class="aside-content" id="aside-content"><div class="card-widget card-info"><div class="card-info-avatar is-center"><img class="avatar-img" src="/liaoyia/null" onerror="this.onerror=null;this.src='/liaoyia/img/friend_404.gif'" alt="avatar"/><div class="author-info__name">John Doe</div><div class="author-info__description"></div></div><div class="card-info-data"><div class="card-info-data-item is-center"><a href="/liaoyia/archives/"><div class="headline">文章</div><div class="length-num">16</div></a></div><div class="card-info-data-item is-center"><a href="/liaoyia/tags/"><div class="headline">标签</div><div class="length-num">9</div></a></div><div class="card-info-data-item is-center"><a href="/liaoyia/categories/"><div class="headline">分类</div><div class="length-num">6</div></a></div></div><a class="button--animated" id="card-info-btn" target="_blank" rel="noopener" href="https://github.com/xxxxxx"><i class="fab fa-github"></i><span>Follow Me</span></a><div class="card-info-social-icons is-center"><a class="social-icon" href="https://github.com/liaoyio" target="_blank" title="Github"><i class="fab fa-github"></i></a><a class="social-icon" href="/liaoyia/2417276459" target="_blank" title="QQ"><i class="fas fa-qq"></i></a></div></div><div class="card-widget card-announcement"><div class="item-headline"><i class="fas fa-bullhorn card-announcement-animation"></i><span>公告</span></div><div class="announcement_content">This is my Blog</div></div><div class="sticky_layout"><div class="card-widget" id="card-toc"><div class="item-headline"><i class="fas fa-stream"></i><span>目录</span></div><div class="toc-content"><ol class="toc"><li class="toc-item toc-level-1"><a class="toc-link"><span class="toc-number">1.</span> <span class="toc-text">MySQL表查询实训笔记</span></a><ol class="toc-child"><li class="toc-item toc-level-2"><a class="toc-link" href="#%E8%AE%BEbookstores%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%89%E4%B8%89%E5%BC%A0%E8%A1%A8%E5%A6%82%E4%B8%8B%EF%BC%9A"><span class="toc-number">1.1.</span> <span class="toc-text">设bookstores数据库有三张表如下：</span></a><ol class="toc-child"><li class="toc-item toc-level-4"><a class="toc-link" href="#book%E8%A1%A8%EF%BC%9A"><span class="toc-number">1.1.0.1.</span> <span class="toc-text">book表：</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#member%E8%A1%A8%EF%BC%9A"><span class="toc-number">1.1.0.2.</span> <span class="toc-text">member表：</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#bookorser%E8%A1%A8"><span class="toc-number">1.1.0.3.</span> <span class="toc-text">bookorser表</span></a></li></ol></li><li class="toc-item toc-level-3"><a class="toc-link" href="#%E5%B7%B2%E5%90%B8%E6%94%B6%E7%9A%84%E7%9F%A5%E8%AF%86%E7%82%B9%E5%9B%9E%E9%A1%BE%EF%BC%9A"><span class="toc-number">1.1.1.</span> <span class="toc-text">已吸收的知识点回顾：</span></a><ol class="toc-child"><li class="toc-item toc-level-4"><a class="toc-link" href="#%E5%AD%90%E6%9F%A5%E8%AF%A2%E4%B9%A0%E9%A2%98"><span class="toc-number">1.1.1.1.</span> <span class="toc-text">子查询习题</span></a></li></ol></li><li class="toc-item toc-level-3"><a class="toc-link" href="#%E5%9C%A8bookstore%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%AE%8C%E6%88%90%E4%BB%A5%E4%B8%8B%E9%A2%98%E7%9B%AE%EF%BC%9A"><span class="toc-number">1.1.2.</span> <span class="toc-text">在bookstore数据库中完成以下题目：</span></a></li></ol></li></ol></li></ol></div></div><div class="card-widget card-recent-post"><div class="item-headline"><i class="fas fa-history"></i><span>最新文章</span></div><div class="aside-list"><div class="aside-list-item"><a class="thumbnail" href="/liaoyia/2020/11/12/hello-world/" title="Hello World"><img src="https://cdn.jsdelivr.net/npm/butterfly-extsrc@1/img/default.jpg" onerror="this.onerror=null;this.src='/liaoyia/img/404.jpg'" alt="Hello World"/></a><div class="content"><a class="title" href="/liaoyia/2020/11/12/hello-world/" title="Hello World">Hello World</a><time datetime="2020-11-12T05:23:35.000Z" title="发表于 2020-11-12 13:23:35">2020-11-12</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/liaoyia/2020/06/26/MySQL%E5%9F%BA%E7%A1%80/" title="Mysql回顾"><img src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymysql.jpg" onerror="this.onerror=null;this.src='/liaoyia/img/404.jpg'" alt="Mysql回顾"/></a><div class="content"><a class="title" href="/liaoyia/2020/06/26/MySQL%E5%9F%BA%E7%A1%80/" title="Mysql回顾">Mysql回顾</a><time datetime="2020-06-26T12:34:53.000Z" title="发表于 2020-06-26 20:34:53">2020-06-26</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/liaoyia/2020/06/22/css%E5%B1%82%E5%8F%A0%E6%A0%B7%E5%BC%8F%E8%A1%A8/" title="Css层叠样式表期末复习"><img src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lyHTML.png" onerror="this.onerror=null;this.src='/liaoyia/img/404.jpg'" alt="Css层叠样式表期末复习"/></a><div class="content"><a class="title" href="/liaoyia/2020/06/22/css%E5%B1%82%E5%8F%A0%E6%A0%B7%E5%BC%8F%E8%A1%A8/" title="Css层叠样式表期末复习">Css层叠样式表期末复习</a><time datetime="2020-06-22T11:08:56.000Z" title="发表于 2020-06-22 19:08:56">2020-06-22</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/liaoyia/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/" title="MySQL表查询实训"><img src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png" onerror="this.onerror=null;this.src='/liaoyia/img/404.jpg'" alt="MySQL表查询实训"/></a><div class="content"><a class="title" href="/liaoyia/2020/04/29/MySQL%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%9E%E8%AE%AD%E7%AC%94%E8%AE%B0/" title="MySQL表查询实训">MySQL表查询实训</a><time datetime="2020-04-29T08:21:56.000Z" title="发表于 2020-04-29 16:21:56">2020-04-29</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/liaoyia/2020/04/09/MySQL%E6%95%B0%E6%8D%AE%E6%9B%B4%E6%96%B0/" title="MySQL数据更新和单表查询"><img src="https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lysee.png" onerror="this.onerror=null;this.src='/liaoyia/img/404.jpg'" alt="MySQL数据更新和单表查询"/></a><div class="content"><a class="title" href="/liaoyia/2020/04/09/MySQL%E6%95%B0%E6%8D%AE%E6%9B%B4%E6%96%B0/" title="MySQL数据更新和单表查询">MySQL数据更新和单表查询</a><time datetime="2020-04-09T08:08:56.000Z" title="发表于 2020-04-09 16:08:56">2020-04-09</time></div></div></div></div></div></div></main><footer id="footer" style="background-image: url('https://cdn.jsdelivr.net/gh/liaoyio/imgHosting/img-lymonvpng.png')"><div id="footer-wrap"><div class="copyright">&copy;2018 - 2021 <i style="color:#FF6A6A" class="fa fa-heartbeat"></i> John Doe</div><div class="footer_custom_text">Hi, welcome to my <a target="_blank" rel="noopener" href="https://liaoyi.xyz/">blog</a>!</div></div><div class="container" id="jsi-flying-fish-container"></div><script src="js/fish.js"></script><style>@media only screen and (max-width: 767px){
#sidebar_search_box input[type=text]{width:calc(100% - 24px)}
}</style></footer></div><div id="rightside"><div id="rightside-config-hide"><button id="readmode" type="button" title="阅读模式"><i class="fas fa-book-open"></i></button><button id="translateLink" type="button" title="简繁转换">繁</button><button id="darkmode" type="button" title="浅色和深色模式转换"><i class="fas fa-adjust"></i></button><button id="hide-aside-btn" type="button" title="单栏和双栏切换"><i class="fas fa-arrows-alt-h"></i></button></div><div id="rightside-config-show"><button id="rightside_config" type="button" title="设置"><i class="fas fa-cog fa-spin"></i></button><button class="close" id="mobile-toc-button" type="button" title="目录"><i class="fas fa-list-ul"></i></button><button id="go-up" type="button" title="回到顶部"><i class="fas fa-arrow-up"></i></button></div></div><div id="local-search"><div class="search-dialog"><div class="search-dialog__title" id="local-search-title">本地搜索</div><div id="local-input-panel"><div id="local-search-input"><div class="local-search-box"><input class="local-search-box--input" placeholder="搜索文章" type="text"/></div></div></div><hr/><div id="local-search-results"></div><span class="search-close-button"><i class="fas fa-times"></i></span></div><div id="search-mask"></div></div><div><script src="/liaoyia/js/utils.js"></script><script src="/liaoyia/js/main.js"></script><script src="/liaoyia/js/tw_cn.js"></script><script src="https://cdn.jsdelivr.net/npm/node-snackbar/dist/snackbar.min.js"></script><script>function panguFn () {
  if (typeof pangu === 'object') pangu.autoSpacingPage()
  else {
    getScript('https://cdn.jsdelivr.net/npm/pangu/dist/browser/pangu.min.js')
      .then(() => {
        pangu.autoSpacingPage()
      })
  }
}

function panguInit () {
  if (false){
    GLOBAL_CONFIG_SITE.isPost && panguFn()
  } else {
    panguFn()
  }
}

document.addEventListener('DOMContentLoaded', panguInit)</script><script src="/liaoyia/js/search/local-search.js"></script><div class="js-pjax"></div><script src="https://cdn.jsdelivr.net/gh/sviptzk/HexoStaticFile@latest/Hexo/js/mouse_snow.min.js"></script><script src="js/jquery.min.js"></script><script src="/js/fish.js"></script><div class="aplayer no -destroy" data-id="000PeZCQ1i4XVs" data-server="tencent" data-type="artist" data-fixed="true" data-mini=" true" data-listFolded="false" data-order="random" data-preload="none" data-autoplay="true" muted></div><script src="/js/fishes.js"></script><script id="click-heart" src="https://cdn.jsdelivr.net/npm/butterfly-extsrc@1/dist/click-heart.min.js" async="async" mobile="true"></script><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/aplayer/dist/APlayer.min.css" media="print" onload="this.media='all'"><script src="https://cdn.jsdelivr.net/npm/aplayer/dist/APlayer.min.js"></script><script src="https://cdn.jsdelivr.net/gh/metowolf/MetingJS@1.2/dist/Meting.min.js"></script><script async data-pjax src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script></div></body></html>